Optimizing Server Settings
High Performance MySQL #MySQL
How MySQL’s Configuration Works
Syntax, Scope, and Dynamism
Persisted System Variables
Side Effects of Setting Variables
Planning Your Variable Changes
What Not to Do
Creating a MySQL Configuration File
Minimal Configuration
Inspecting MySQL Server Status Variables
Configuring Memory Usage
Per-Connection Memory Needs
Reserving Memory for the Operating System
The InnoDB Buffer Pool
The Thread Cache
Configuring MySQL’s I/O Behavior
The InnoDB Transaction Log
Log Buffer
The InnoDB Tablespace
Other I/O Configuration Options
Configuring MySQL Concurrency
Safety Settings
Advanced InnoDB Settings
Summary